SUMMARY

• Experienced developer with the ability to execute data reporting services and report development activities and translate these into a relevant interactive Dashboard. Able to design, create, manage and correctly distribute various styles of Reports and Dashboards empowering end - users to make informed decisions.
• Projects - Operated as Lead Developer on numerous BI Projects working with a Project Manager and a Business Analyst using a Business Requirements Document to meet the needs of the project sponsors and stakeholders. Also experienced with Agile and works efficiently within a Scrum team.
• Dashboards - Able to create multi-level, highly visual Dashboards using 3-D graphs, widgets, conditional formatting, text labels, borders, tables, gradients, and background colors with an emphasis on single screen/summary level data, often containing drill-down links to more granular data.
• Mobile - Operated as Lead Developer on numerous projects developing multi-level Mobile Dashboards for the iPad and iPhone containing GPS coordination, 3-D Graphs, widgets and swipe technology.
• Applications - Tableau 8.1 through 9.0 Desktop and Server to create Reports, Documents, Dashboards. Proficient in building complex cubes and datasets that hit multiple fact tables. Proficient in building compound, level and nested metrics, hierarchies, prompts, filters, consolidations, derived elements, custom groups, transformations, parameterized links, extracts and using all other Tableau related functions.
• Architecture - Able to design a project and connect to multiple sources. Able to create database connection and instance to build project using any driver or ODBC connection. Writing custom SQL to create data layer for analytics. Create advanced Calculated Fields to act as metadata layer in Tableau.
• Business - Experienced in Retail business including Warehouse Management, Supplier Relations, Purchasing Systems, Distribution and Supply Chain Management. Experience in the Cable Domain.
• Administration - Operating as a Project Administrator within the Tableau Server. Manage user and project permissions. Able to document discrepancies using Integrity Manager. Able to manage subscriptions within the enterprise.
• Documentation - Completed a Technical Design Document for each project to chronicle the development process for developers in future iterations. Worked with Migration Documents to allow things to move from DEV - TEST - PROD.
• Managing Timelines - Able to estimate and properly execute schedules, projects, Documents, Dashboards and Reports on time. Used to working in a fast paced, high pressure environment.
• Collaboration – Excels in communication, able to work closely with other team members to develop, troubleshoot and validate data and Reports. As well as collaborating to create design standards. Creative problem solver with the business acumen necessary to communicate clearly.
• Design – Able to design and implement data queries to gather needed information. Able to perform custom queries for clients and internal staff to create Ad Hoc, scheduled and on demand Reports in near real-time. Able to determine the end-user’s specific needs to deliver a clear and concise Report or Dashboard with no clutter or unnecessary information.
• Evaluation – Able to evaluate and analyze current data and data management procedures with precision and help discover new approaches that will increase efficiency and influence effective decision making.
• Data – Proficient in working within a relational database using a star or snowflake schema in a Dimensional Data Model. Experienced in working with a DBA and Data warehouse team to understand the schema of a database structure and understand the data sources within the company. Experience with Oracle 9 and SQL Developer. Using SQL developer, able to validate data and fine tune performance. Experienced with VLDB setting adjustments to improve performance. Experienced with Hadoop and Big Data content connected to Tableau. Experienced using a direct connection to SmartSheet via ODBC. Experience using Alteryx.
• Solutions – Ability to troubleshoot and find solutions to problems with patience and find workarounds when appropriate.
• QA – Experienced in working closely with a Quality Assurance team to verify results prior to production release to the business.
• Upgrades – I have been involved in several Tableau upgrades 8.1 through 9.0 and played a pivotal role in the transition.
• Training – Experienced training end users as well as developers/ analysts to utilize all facets of Tableau development.
• Other Applications - Experience with MicroStrategy, Crystal Reports, Alteryx. Able to publish to Outlook, Excel, SharePoint, Word, PDF, mobile devices, printed material or through an ODBC. Able to publish and automate reports onto Crystal Server. Proficient in all Microsoft Office programs.

PROFESSIONAL EXPERIENCE

Confidential

Lead Tableau Developer/ Administrator

Responsibilities:

• Design and Development of the Standby Power Supply Dashboard project.
• Assisting in building SQL Server as backend data source.
• Building advanced data blends using Alteryx.
• Utilizing WMS servers for Geo code visualizations.
• Validating datasets by writing queries and comparing results to the analytic.
• Developing and maintaining design
• Engaging with Business Analyst and end-users to analyze requirements and improve development.
• Following unit testing, working closely with the QA department to validate datasets and move through the testing process prior to production release.
• Following production migration, working with the team to make adjustments/ additions during the warranty period.
• Training end-users to utilize reports and dashboards to their full capacity.
• Training other developers in the department to develop and design using Tableau desktop and Server.
• Support of production analytics following the completion of the life-cycle.

Confidential

Lead Tableau Developer/ Administrator

Responsibilities:

• Collaborating with a Project Manager, using ODBC connected to SmartSheet to design often complex Extracts/ Datasets and implement; Reports, interactive Dashboards, Mobile Dashboards for 21 separate departments. Operated as a Project Administrator for the Tableau Server environment.
• Documenting development with a Technical Design Document and Migration Document and maintaining these on a SharePoint site.
• Validating datasets by writing queries and comparing results to the analytic.
• Developing and maintaining design standards for the BI team.
• Engaging with Business Analyst and end-users to analyze requirements and improve development.
• Following unit testing, working closely with the QA department to validate datasets and move through the testing process prior to production release.
• Following production migration, working with the team to make adjustments/ additions during the warranty period.
• Training end-users to utilize reports and dashboards to their full capacity.
• Training other developers in the department to develop and design using Tableau desktop and Server.
• Support of production analytics following the completion of the life-cycle.
• Played a pivotal role in the upgrades from 8.3.1 to 8.3.4 and then to 9.0

Confidential

Lead Tableau Developer/ Administrator

Responsibilities:

• Collaborating with a Project Manager, Data Analyst, Business Analyst and Data Warehouse team to design often complex Cubes/ Datasets and implement; Reports, interactive Dashboards, Mobile Dashboards and Visual Insight analysis for several departments. Operated as a Project Administrator for the Tableau/ Hadoop environment.
• Documenting development with a Technical Design Document and Migration Document and maintaining these on a SharePoint site.
• Experienced working with Suppliers/Assigned Account Reps and all facets inside a Supply Chain system.
• Created dashboards and reports to manage the Product Distribution Warehouse.
• Validating datasets by writing queries in SQL Developer and comparing results to the analytic.
• Developing and maintaining design standards for the BI team.
• Engaging with Business Analyst and end-users to analyze requirements and improve development.
• Following unit testing, working closely with the QA department to validate datasets and move through the testing process prior to production release.
• Following production migration, working with the team to make adjustments/ additions during the warranty period.
• Training end-users to utilize reports and dashboards to their full capacity.
• Training other developers in the department to develop and design using Tableau and MicroStrategy Desktop and Server.
• Assisted in transforming the BI infrastructure from MSTR to Tableau.
• Support of production analytics following the completion of the life-cycle. Played a pivotal role in the upgrades.

Confidential

Responsibilities:

• Collaborating with a Project Manager, Data Analysts, Business Analysts and Data Warehouse team to design often complex Cubes/ Datasets and implement; interactive Dashboards, Mobile Dashboards and Visual Insight analysis for Technical operations.
• Training analysts and developers to create MicroStrategy reports and documents.
• Documenting development with a Technical Design Document and Migration Document and maintaining these on a SharePoint site.
• Validating datasets by writing queries in SQL Developer and comparing results to the analytic.
• Engaging with Business Analyst and end-users to analyze requirements and improve development.
• Following production migration, working with the team to make adjustments/ additions during the warranty period.
• Support of production analytics following the completion of the life-cycle.
• Played a pivotal role in the upgrades from 9.3.1 – 9.4.1

Confidential

Lead Crystal Reports Developer

Responsibilities:

• Developing new reports using Crystal Reports XI in MS SQL based on existing reports in Oracle.
• Documenting development with a Technical Design Document and maintaining these on a SharePoint site.
• Validating datasets by writing queries in SQL Developer and comparing results to the analytic.
• Discovering new ways to improve performance of current reports.
• Developing and maintaining design standards for the BI team.
• Engaging with Business Analyst and end-users to work through reporting needs.
• Publishing and automating finished reports onto the Crystal Server using InfoView.
• Training other developers in the department to develop and design using Crystal Reports XI.
• Support and maintenance of analytics following the production release migration.

Confidential

Lead MicroStrategy Administrator

Responsibilities:

• Created database connection and instance to build project using Intelligence Server Architect. Using Object Manager, created Facts, Attributes and Hierarchies to be used in report development.
• Utilizing MicroStrategy reporting tools, I was able to collaborate with the Data Warehouse team and develop reports in the reorganization and automation their data management system.
• Documenting schema object mapping.
• Maintained User Groups.
• Collaborated with a Business Analyst and Data Warehouse team to design complex Cubes/ Datasets and implement prompted and automated reports containing parameterized links.
• Documenting development with a Technical Design Document.
• Validating datasets by writing queries in SQL Developer and comparing results to the analytic.
• Developing and maintaining design standards for the BI team.
• Engaging with Business Analyst and end-users to analyze requirements and improve development.
• Maintained production support for end users.
• Maintained an optimum environment using the Admin tools within the MSTR suite.
• Managed access to User Groups.
• Used VLDB properties to enhance performance within any environment.
• Managed migrations between environments using Object Manager.
• Documented discrepancies using Integrity Manager.
• Managed subscriptions within the enterprise.
• Creating prompted reports allowed them to enter criteria and run reports from their database.
• Responsible for case management of clients in assisting them in daily living skills.
• Conducted and took the lead for mental health groups.
• Completed progress notes after group meetings for each individual client.
• Develop complex, multi-level reports using Crystal Reports 2008.
• Engaging with a Business Analyst to obtain end user requirements.
• Validate results using SQL developer.
• Finding creative solutions to develop reports based on reporting needs.
• Discovering new ways to improve the current reports.
• Keeping up with the pace of DW changes as they happen.
• Meeting with end-users to analyze requirements and improve development.
• Documenting development with a Technical Design Document and maintaining these on a SharePoint site.
• Training other developers in the department to develop and design using Crystal Reports 2008.
• Support and maintenance of analytics following the production release migration.

Confidential

Lead Crystal Reports Developer

Responsibilities:

• Develop complex, multi-level reports using Crystal Analysis.
• Engaging with the IT department to obtain end user requirements.
• Validate results using SQL developer.
• Finding creative solutions to develop reports based on reporting needs
• Discovering new ways to improve the current reports
• Keeping up with the pace of DW changes as they happen.
• Meeting with end-users to analyze requirements and improve development.
• Documenting development with a Technical Design Document and maintaining these on a SharePoint site.
• Validate results using SQL developer.
• Training other developers in the department to develop and design using Crystal Analysis.
• Support and maintenance of analytics following the production release migration.