Livecareer-Resume
Jessica Claire
  • Montgomery Street, San Francisco, CA 94105
  • H: (555) 432-1000
  • C:
  • resumesample@example.com
  • Date of Birth:
  • India:
  • :
  • single:
Professional Summary
Highly-skilled software development professional with over 6 years of experience in Tableau. Advanced knowledge of data discovery, data visualization, data analysis, and report development as a MS SQL Server Developer/ ETL Developer in analysis, design, implementation & administration of Business intelligence solutions (SSIS/SSRS/SSAS) with Microsoft SQL server 2012/2008-R2/2008/2005 in development, testing & production environment. Expert web developer specializing in front end development and experienced manager versed in all stages of the development cycle for dynamic web projects. Hands on experience in migrating the data warehouse from Oracle to Teradata. Involved in Troubleshooting, Performance tuning of reports and resolving issues within Tableau Server and Tableau desktop report Experience in Installation, Configuration and administration of Tableau Server in a multi-server and multi-tier environment. Established Best Practices for Enterprise Tableau Environment and application intake and development processes. Extensive experience in Tableau Administration Tool for Configuration.  Extensively used Erwin for Logical Data Modeling, Physical Data Modeling, Logical-to-Physical Transformation, Forward engineering, Reverse engineering, and Model-to-model comparison. Strong knowledge of Data Warehousing methodologies and concepts.
Technical Skills & Technology
Tableau Desktop, Tableau Reader, Tableau Public, Tableau Server 9/8/7/6, Tabcmd, MS SQL Server 2012/2008R2/2008/2005, MS SQL Server Integration Service (SSIS), MS SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), BCP, SQL Profiler, Enterprise manager, Management studio, Microsoft Access, ERWIN 4.0/4.1/4.2/7.2, Microsoft Visio 10.0/11.0, T-SQL, ASP.NET, C#, VB.Net, HTML, XML, XSL, Oracle 11g/10g Crystal Reports 8.5/9/10/11,TFS, Visual source safe 2005, MS office 2013/2010/2007/2003, Windows 2008/2003 Advanced Server/Professional, Windows NT 4.0 Server/Workstation, UNIX, Perl, VBScript, JavaScript, Dreamweaver CS4, Web Updater II,SPSS, SharePoint 2013. MS SQL Server 2005/2008, SQL Server Reporting Services, T-SQL, Crystal Reports 10,Visual Studio 2005/2008,Erwin, MS Office 2003/2007, SQL Profiler, Windows server 2003.
Work History
Tableau Developer/Admin, 03/2015 - Current
Sheridan HealthCare City, STATE,
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
  • Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions. Implemented various data connections from data source to Tableau Server for report and dashboard development.
  • Converted charts into Crosstabs for further underlying data analysis in MS Excel.
  • Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
  • Combined visualizations into Interactive Tableau Dashboards and published them to the web portal (SharePoint).
  • Assigned Permissions to the different Lines of Businesses and Users.
  • Was also responsible for the performance of the tableau Dashboards on the web portal.
Tableau Developer/Admin, 2013 - 02/2015
Horizon Blue Cross Blue Shield City, STATE,
  • Created complex dashboards in Tableau using parameters, sets, groups, and calculations. Also built automated reports, report templates and delivered BI solutions.
  • Evaluated data models to design Tableau solutions.
  • Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards.
  • Involved in creating dashboards by extracting data from different sources.
  • Created interactive dashboard and applied actions like filter, highlight and URL to dashboard.
  • Created calculated fields, combine field, bins, sets, geo coding and hierarchies using Tableau Desktop.
  • Implemented proof of concepts on Hadoop stack and different big data analytic tools, migration from different databases (i.e Teradata, Oracle, MySQL) to Hadoop.
  • Performed Tableau type conversion functions when connected to relational data sources.
  • Maintained and installed Tableau Server in all environments.
  • Created incremental refreshes for data sources on Tableau server.
  • Monitored VizQL server, Application Server and data server activity to track performance and system stability.
  • Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
  • Administered user, user groups, and scheduled instances for reports in Tableau Generated insights out of voluminous and complex datasets and built story lines.
  • Used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository Configured Cache settings which improved the performance of the reports and Dashboards.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business changes to ensure that the views and dashboards displayed the changed data accurately.
  • Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Created bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
  • Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Tableau Developer/Admin/SQL Developer, 2011 - 11/2012
AIG City, STATE,
  • Worked on strategic reporting development, creating interactive dashboard and visualization of data solutions to support various business operations utilizing Tableau Software and SQL.
  • Worked in coordination with clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.
  • Created Users, Groups, and Projects as well as managed user schedules in Tableau environment.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
  • Created different views using Tableau Desktop that were published the business stake holders for analysis and customization using filters and actions.
  • Created Heat Map showing employment vs unemployment by color that were broken into regions allowing business user to understand where we have most unemployment.
  • Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
  • Created Bullet graphs to determine average wages and workers compensation by using measures and dimensions data from Oracle SQL Server and MS Excel.
  • Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.
  • Created trace in SQL Profiler and used Database Engine Tuning Advisor (DTA) for Performance tuning on stored procedures and Scripts.
  • Performed T-SQL tuning by using Database Engine Tuning Advisor for long execution plans.
  • Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
  • Created Bar Charts complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
  • Built the database system in the Access software and data management systems, quality control system, and conducted programming and data quality checks and validation.
  • Developed and documented programs to create analysis data sets, summarizing key trial data and SPSS for statistical analysis, documentation, and reporting.
  • Managed, cleaned and constructed analytical files.
  • Developed, modified and validated SPSS programs to produce customized weekly and monthly, quarterly, and yearly statistical analysis reports on production operations for risk management and quality improvements by the plant management team.

Tableau Developer/Analytics Reporting Project, 07/2016 - Current
Bank Of America City, STATE,
  • Generated graphical representations of financial activities- time series analysis, visual analysis of content and performed some outlier analysis dashboards with tableau.
  • Provided the Financial crime Investigators with a dashboard that searched across multiple transactional data sources to see information relevant to our customers, their accounts and wires in different locations. 
  • Working on some Anti Money Laundering and OFAC related dashboards for our other lines of businesses.
  • Introduced self-service as a concept – With weekly trainings and WebEx sessions our business users are now able to generate quick and advanced visualizations to explore data and detect trends and patterns.
  • With tableau we now have a visual discovery of Customers, accounts and wires and the future ability to search across other transactional data sources.  
  • Tableau training partner, I have prepared several documentations for all the dashboards and trained our users on how to utilize these documents.
  • Tableau site Admin- Publishing and removing and granting permissions to the published dashboards.
MS SQL Developer/SSRS Developer/Tableau Developer, 11/2009 - 11/2010
Health Talk Inc City, STATE,
  • Built data warehouse to analyze transactions across all the departments and generating Reports using SSRS.
  • Involved in all the phases of SDLC.
  • Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
  • Used Stored Procedures for updating Servers.
  • Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
  • Wrote Complex Stored Procedures, Triggers, Views and Queries.
  • Created indexes, Constraints and rules on database objects.
  • Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS and then created reports using this data using SSRS.
  • Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.
  • Generated reports using Cross-Tab, Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
  • Identified the database tables for defining the queries and defined datasets for report generation.
  • Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
  • Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Generated daily, weekly and monthly reports for the managers.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
  • Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
  • Tested the reports and fixed bugs in the stored procedures.
  • Created Advance connections, join new tables, create, manage, extract and monitor queries.
  • Created extract files for improving the performance and set functionality.
  • Used different mark types and mark properties in views to provide better insight into large data sets.
  • Created various types of charts to provide better visualizations.
  • Created complex data views manually using multiple measures, and also used sort, filter, and group.

Education
Bachelors of Science (IT): , Expected in
-
Virginia Wesleyan College - , VA
GPA:

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Disclaimer

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

School Attended

  • Virginia Wesleyan College

Job Titles Held:

  • Tableau Developer/Admin
  • Tableau Developer/Admin
  • Tableau Developer/Admin/SQL Developer
  • Tableau Developer/Analytics Reporting Project
  • MS SQL Developer/SSRS Developer/Tableau Developer

Degrees

  • Bachelors of Science (IT)

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in: