We provide IT Staff Augmentation Services!

Sr. Tableau Developer / Administrator Resume

Atlanta, GA

SUMMARY:

  • 7+ years of IT experience in Software Analysis, Data Analysis, System Analysis, Design, Development, Testing and Implementation of application.
  • Strong experience in Pharmaceutical, CRO, Health Care, Financial and Insurance domain.
  • Experience in Business Analysis, Business Intelligence, Data Warehousing, Data Mining, Data Warehousing applications and Tableau.
  • 3 Years of Tableau BI Reporting experience using Tableau Desktop version 7x, 8x,9x Tableau Server, Tableau Administration and Tableau Reader creating Worksheet, Graphs, Charts and Dashboard.
  • Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
  • Worked on the development of Dashboard reports for the Key Performance Indicators for the top management.
  • Expertise in Developing User Objects (filters, prompts, metrics, Sets and Groups, Calculated Fields) to develop Documents and reports.
  • Experienced in developing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
  • Experience in Clinical Data Analysis, Producing Reports, Listings, Tables, Graphs, and Summaries from clinical trial data for various phases of Clinical Trials.
  • Involved in the process of generating datasets and Tables/Listings for Integrated Summaries of Safety (ISS) for FDA Submission.
  • Database Programming experience using Oracle 10g/9.x/8.x/7.x/, MS SQL Server, DB2, PL/SQL, SQL, SQL Loader, TOAD, PL/SQL Developer and Benthic Golden.
  • Expertise in preparing Test Plans, Cases & Scripts based on system specifications and A&D documents.
  • Expertise in Regression, System, Integration, Functional and Performance Testing.
  • Participated in various meetings between Offshore and Functional Team to review business requirements, and Functional clarifications.
  • Work independently with business analysts to gather the requirements.
  • Excellent communication and administration skills, highly motivated and with an aptitude for success and able to work in a team environment with minimum supervising.
  • Database management with SQL and PL/SQL. Managed Oracle and MySQL using SQL Developer.

TECHNICAL SKILLS:

Business Intelligence tools: Tableau 7x/8x/9x, Tableau Server, Retrieving data using Universes, Personal data files, Stored Procedures and Freehand SQL methods

Languages: C, C++, T - SQL, XML, HTML, JavaScript, JQuery, .NET (ASP.NET, C#, VB.NET), UML.

Databases: MS SQL Server, Oracle, MS Access Teradata 12.0/V2R5/V2R4, Oracle 11g,10g/9i/8i/7.x, MS SQL Server 2005/2000/7.0/6.5

Other Tools: Microsoft Project, Microsoft Visio HP Service Manager

Operating System: MS DOS, WinNT/2000/7, and UNIX

Big Data Ecosystems: Hadoop, MapReduce, HDFS, HBase, Zookeeper, Hive, Pig, Sqoop, Cassandra, Oozie, Flume, Chukwa, Pentaho Kettle and Talend

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Tableau Developer / Administrator

Responsibilities:

  • Built Strategic, Analytical and operational dashboards using Tableau.
  • Involved in reviewing business requirements and analyzing data for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
  • Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions, converted charts into Crosstabs.
  • Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
  • Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and worked independently for the End User Requirements.
  • Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
  • Developed geographic maps showcasing demographics broken into age, race, and income category that showed content viewed by individual customers across all content providers.
  • 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.
  • Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
  • Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.
  • Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
  • Strong knowledge of Hadoop, Hive and Hive’s analytical functions.
  • Informatica Power Center, via Informatica Power Exchange, connected to Mainframe systems to provide access data in various formats such as VSAM, IMS, IDMS, ADABAS etc. through Data Maps that act as SQL Views.
  • Assisted in identifying and migrating data sources to tableau server
  • Implementing best-practices for the dashboards with a solid understanding of the use of Contexts and their impact on performance.
  • Develop Ad-hoc reports according to user's requests.
  • Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
  • Involvement in end-to-end activity of dashboard development from requirements gathering to deployment phase.
  • Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop v7.0, v8.1, v8.3, v9.0, v9.1, v9.2 Tableau Server, Oracle 10g, MS SQL Server 2005, MS Excel, Windows.

Confidential, Mooresville, NC

Sr. Tableau Developer/Administrator

Responsibilities:

  • Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.
  • Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.
  • Analyzed data from various databases and formatted it into graphs using Tableau Desktop.
  • Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
  • Blended data from multiple databases such as MS Excel, Oracle and SQL database by assigning primary key from each databases.
  • Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
  • Creating New Schedule's and checking the task's daily on the server
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard.
  • Executed and tested required queries and reports before publishing dashboards.
  • Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
  • Executed and tested required queries and reports before publishing dashboards with help of User Acceptance Testing (UAT) and System Integration Testing(SIT).
  • Presented, interacted, and communicated with business and user groups for explaining the dashboards that I have created with the ability to change and view the data on the fly.
  • Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.
  • Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure.
  • Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards.
  • Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

Environment: Tableau Desktop v8.1, Tableau Server, Oracle 10g, MS SQL Server 2005, MS Excel, Windows.

Confidential, Washington, DC

SQL Developer / MS BI

Responsibilities:

  • Involved in different phases of SDLC process of design, development and testing of License Information Repository application using SQL Server.
  • Participate in up gradation and migration of data from SQL
  • Modified a number of existing stored procedures based on the changes made to existing tables.
  • Migrated DTS packages to SSIS packages. Worked with slowly changing dimensions type 2. Created SSIS packages to perform cube processing from staging to Analysis Services Cube. Developed aggregated queries to populate the fact tables.
  • Created a MOLAP Cube on SQL Server 2005 Analysis Services as an alternative prototype to an existing relational data mart.
  • Handled millions of records on changing dimensions as well as facts in SSAS.
  • Developed numerous reports off OLTP Servers using Reporting Services by writing T-SQL queries, stored Procedures with parameters, charts and multiple datasets.
  • Created reports with Analysis Services Cube as the data source using SQL Server 2005 Reporting Services.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Crystal Reports, SharePoint 2007, T-SQL, ODBC, Excel, Access, Windows 2000/XP.

Confidential

SQL Developer

Responsibilities:

  • Design database and implement application database objects such as tables, stored procedures, user defined functions, views.
  • Provide database coding support to application development team.
  • Maintain SQL Scripts for changes in database objects.
  • Provided support for database backup/restore and database transfer activity from test environment to production environment.
  • Design and develop data transformation processes. Design and develop SSIS packages for data transformations and importing into new database.
  • Design T-SQL code blocks. Design database and implement application database objects such as tables, stored procedures, user defined functions, views.
  • Provide database coding support to application development team. Maintain SQL Scripts for changes in database objects.
  • Provided support for database backup/restore and database transfer activity from test environment to production environment.
  • Implement application database objects such as tables, stored procedures, user defined functions, views. Provide database coding support to application development team. Maintain SQL Scripts for changes in database objects.
  • Provided support for database backup/restore and database transfer activity from test environment to production environment.

Environment: MS SQL Server 2008 R2/ 2005, SQL Server Management Studio, Crystal

Hire Now