Skills
& Expertise
Technology
-
MicroStrategy
-
SQL
-
DBeaver
-
Visual Studio Code
-
HTML/CSS
-
ThoughtSpot
-
Toad
-
Oracle SQL Developer
-
Tableau
-
MDX
-
SSMS
-
SSRS
-
Visual Studio
-
Qlik Sense
-
QlikView
Last Used
2024
2024
2024
2023
2023
2023
2021
2020
2020
2019
2019
2019
2019
2018
2017
Years of Experience
3
10
1
< 1
< 1
< 1
1.5
1
< 1
<1
4
2
2
< 1
4
Skill Level
* * * * * * * * * *
* * * * * * * * * *
* * * * * * * * * *
* * * * * * * * * *
* * * * * * * * * *
* * * * * * * * * *
* * * * * * * * * *
* * * * * * * * * *
* * * * * * * * * *
* * * * * * * * * *
* * * * * * * * * *
* * * * * * * * * *
* * * * * * * * * *
* * * * * * * * * *
* * * * * * * * * *
Certifications
MicroStrategy Project Architect
Issued: May 2023
ThoughtSpot Business User
Issued: May 2023
MicroStrategy Analyst
Issued: May 2020
Work
Experience
2020 - Present
Sr. Data Analytics Engineer
SMX, Remote
• MicroStrategy Developer
- Design and develop documents and dossiers. Create attributes, facts, and metrics for use in datasets. Create SQL code to create views and to test data in database.
• Data Analyst
- Serve as Lead in data mapping project task.
- Map data between legacy reports and new Pega application.
- Coordinate with multiple teams to learn requirements and understand all data points.
• Scrum Master
- Lead daily standups and manage Jira board for project team.
- Provided weekly project updates to department
• Web Developer
- Built a static HTML modal window as an initial POC for a new web application
2015 - 2020
Consultant (BI Developer)
Deloitte, Lake Mary, FL
Developed and designed various data visualization dashboards for multiple projects and clients utilizing Qlik Sense, QlikView, Tableau, and SSRS. Utilized SQL to gain understanding of underlying data from various databases. Assisted more junior developers. Served as co-lead on the Qlik CoP and MicroStrategy CoP.
• Tableau Developer
- Developed Tableau dashboards utilizing LOD expressions, actions,
parameters, filters, and blending and joining different data sources.
Published Tableau workbooks to the server.
- Created SQL views to consolidate data from multiple tables in order to be used as data sources.
- Adviced on, proofed, and edited junior BI Developers’ dashboards.
- Proofread Python code for validating incorporating business rules into
ETL, validated and prepared data.
• SSRS Developer
- Reverse-engineered Cognos dashboards to recreate in SSRS.
“Dissected” Cognos reports to understand the data and business
requirements used to create individual charts. Dug out the logic of
nested queries, interpreted the generated SQL, and identified
conditional formats. Used that understanding to design and develop
SSRS dashboards. Wrote MDX code to pull data from cubes. Wrote
SQL statements to validate base data within SQL Server.
• QlikView Developer
- Rebuilt, remodeled, and recoded two separate QlikView dashboards to
combine them into one. Reworked design and code of two QlikView
dashboards with emphasis on creating a complete user ad hoc reporting
section.
• Qlik Sense Developer
- Developed a QlikView and Qlik Sense training document. Built Qlik
Sense prototype dashboards that heavily utilized API extensions (i.e.,
HTML, CSS, and JavaScript).
- Won 3rd place in Qlik Data Blitz for Qlik Sense dashboard.
2015 - 2015
QlikView Developer
Capital Staffing Solutions, Jacksonville, FL
Contracted at Deutsche Bank to convert a departmental QlikView dashboard from a stand-alone version that utilizes CSV files to a server-side version that connects to various Oracle databases.
• Decreased load time of original stand-alone dashboard by 50% via incremental loads and recovered the missing 70% of data by fixing code errors.
• Used enterprise data model to learn about the underlying data and their relationships.
• Performed detailed analysis of source system data. Analyzed underlying data for potential discrepancies and investigated errors. Utilized SQL within Oracle SQL Developer.
• Designed, developed, and tested QlikView scripts to import data.
• Worked on creating proper star schema data model for dashboard.
2011 - 2015
Data Analyst / QlikView Developer
Seneca Resources Corporation, Pittsburgh, PA
Supported/augmented the Drilling Engineers with various activities and data analysis, including, but not limited to review of daily reports, data compilation, and report generation. Assisted WellView Administrator with troubleshooting data and reporting issues. Acted as interim WellView Administrator in between previous full-time administrators. Provided end user support for QlikView and WellView.
• Designed, developed, and supported QlikView dashboards. Integrated data sources and databases with QlikView, and designed and developed data models and backend queries for presenting data.
• Created data queries and reports using WellView, QlikView, Visual Studio, SQL Server Management Studio, SSRS, and Excel. Created custom queries/reports designed for quality verification and information sharing.
• Used SQL, PowerPoint, Excel and InfoView daily to generate various performance reports for analysis.
• Analyzed underlying data for potential discrepancies, investigate errors, and perform data cleanup.
• Set up wells and jobs within WellView; monitored and QC’d daily WellView data for anomalies.
2010 - 2011
Data Analyst
Titan Consulting, Pittsburgh, PA
Assigned to General Dynamics Wireless Services providing them with data analytics support. Responsible for providing data management and data reporting for the local office. Assist team members with data questions and issues and Excel problems.
• Created reports for data collection and decision-making. Used Excel formulas, VBA, and SQL as needed.
• Compiled data from multiple sources into a master Excel tracker.
• Worked on the data model to be used as the blueprint for converting the Excel tracker to Access.
2009 - 2010
Data Analyst
Education Management Corporation, Pittsburgh, PA
Responsible for providing reporting and analytical support to three VPs for school start information on a monthly basis. Provided data reporting and analytical support to Email Marketing team on a weekly basis. Ran standard and ad hoc queries for various teammates. Worked primarily with SQL Server, CampusVue, and Responsys.
• Created dashboards to be used for executive decisions.
• Provided insight into data presented and offered suggestions on possible improvements.
• Utilized SQL and Excel formulas and functions extensively to extract, cleanse, manipulate, and prepared data for analysis.
Education
Old Dominion University | Master’s Degree
Applied Linguistics, GPA 3.7
Old Dominion University | Bachelor's Degree
Spanish, GPA 3.2
J. Sargeant Reynolds Community College | Associate's Degree
Liberal Arts, GPA 3.4