We provide IT Staff Augmentation Services!

Sr. Tableau Developer/sas Consultant Resume

Detroit, MI

Career Summary:

A result oriented professional with 8 Years’ experience in SAS & Tableau Business Analytics Platform which includes Enterprise Business Intelligence (EBI), SAS Grid/Platform Administration, Data Integration, statistical modeling, predictive modeling with 9.3/9.2/9.1vs. Currently positioned in Data visualization tool Tableau 7.0/8.0vs.

Tableau Skills:

  • Having 3+ Years of Tableau experience (Tableau Desktop and Tableau Server) Analysis, Design, Development and Maintenance phases providing end to end solutions on Data Warehousing projects.
  • Involved in Full Life Cycle Development of Reporting Projects, includes Requirements Gathering/ analysis, Design, Development, Testing and Production rollover.
  • Involved in Trouble Shooting, Performance tuning of reports and resolving issues with in Tableau Server and Reports.
  • Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, calculations and Relationships.
  • Involved in Trouble Shooting, Performance tuning of reports and resolving issues with in Tableau Server and Reports.
  • Having knowledge on gather business requirements and translate them into reporting needs.
  • Recommending Dashboards per Tableau visualization features and delivering reports to Business team on timely manner.
  • Successfully upgraded Tableau platforms in clustered environment and performed content Upgrades.
  • Established Best Practices for Enterprise Tableau Environment and application intake and Development processes.
  • Designing, Developing and supporting interactive Tableau Dashboard reports.
  • Experience in Marks, Publisher, Security concepts, creating Worksheets and Dashboard using Tableau.
  • Proficient in understanding and writing of complex SQL queries and stored procedures
  • Good understanding of design of relational databases, queries, views, reports and macros
  • Sound knowledge of Data warehousing Concepts ,OLAP models and OLAP Reporting Solutions
  • Solid Experience on Databases SQL Server 2000,SQL Server 2005,MS Access & Oracle 9i with data analysis and validation
  • An effective communicator with exceptional relationship management skills with the ability to relate working with customers, projects managers and technical teams.

SAS Skills

  • Creating SAS datasets, reports, tables, listings, summaries and graphs according to specifications given in SAP and departmental guidelines in the SOP on Windows and UNIX platforms
  • CDISC Mapping & Creation of SDTM, ISS, ISE datasets, tables and listings for FDA submissions
  • Creating critical SAS macros, modified and validated existing ones for new studies
  • Proficient in transforming datasets using techniques of merging, interleaving and stacking datasets
  • Generating tables employing various SAS data steps and procedures
  • Data Manipulations using SAS procedures such as SAS Formats/Informats, Proc SQL, Proc Sort, Proc Transpose and Proc CDISC.
  • Statistical SAS procedures, graphs and plots.

Technical Skills

BI Tools and other : Tableau 8.2/8.1/8.0/7.0 , SAS 8.2/9.1.3, SAS/BASE, SAS/STAT, SAS/GRAPH.

Database Applications : Teradata 13.0 SQL, Hadoop, Hive, Oracle 9i/10g, Data Warehouse Concepts

Programming Languages : SQL and PL/SQL, HTML, C#,

Operating System : Windows 2000, Windows XP, Windows 7, UNIX.

Professional Experience:

Confidential, Detroit, MI

Sr. Tableau Developer

Roles and Responsibilities

  • Created dashboard views from NetMining, Dealer.com and UPTRACKS.
  • Worked on Inventory, Sales and Service, Advertising, Social, Website, Leads, Website Metrics to create the visualization dashboards for the Dealers.
  • Created KPIs across channel presence, digital media reach and engagement into a single Digital IQ scorecard. Evaluated the score for each dealer, zone and region and nationally to gauge system performance using the Tableau.
  • Created Rich Graphic visualization/dashboards to enable a fast read on sales and key business drivers and to direct attention to key area
  • Incorporated a regional and national comparative / benchmark metrics to give context to individual performance
  • Online and offline KPIs are included for sales and inventory data through Paid Search and CRM
  • Created a proof of concept for the optimal data integration process.
  • Designed high-level view of the current state of dealer operation, leads, and website activity using Tableau
  • Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI’s
  • Created workbooks and Dashboards using calculated metrics for different visualization requirements
  • Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.

Environment: Tableau Desktop 8.2/8.1, Tableau server / Administrator, tabcmd, Hadoop, HDFS, Map Reduce, Hive, Sqoop, UNIX.

Confidential, MI

Tableau Specialist

Responsibilities:

  • Worked with business analysts, interpreted business requirements that users looked to dashboards to answer, and created server based Tableau dashboards with automatic updates.
  • Defined best practices for Tableau report development.
  • Implemented Tableau BI Dashboard reporting solution for different groups in the organization.
  • Published Dashboards onto Tableau Server and from there consumers would choose viewing medium (laptop, pc, IPad)
  • Created extensive joins for data blending from several different data sources
  • Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps
  • Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
  • Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics
  • Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
  • Leveraged advanced features of tableau such as calculated fields, parameters, and sets to support data analysis and data mining.
  • Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
  • Tested Dashboard for data accuracy and Functionality.
  • Migrated Reports & Universes from Development to Testing and to Production Environment using Import Wizard.

Environment: Tableau 6.0, Business Objects 3.1, Universe Designer, Oracle 9i, Unix, SAP BW 7.0

Confidential, Austin, Texas

SAS & Tableau Developer

Responsibilities

SAS Developer Activities:

  • Consolidating data from different sources like DB2, SQL Server & Oracle for data manipulation and data cleansing purpose using SAS Data Integration Studio 4.2 and SAS Enterprise Guide.
  • Developed models for various profiling and customer segmentation for business and personal banking.
  • Streamline the various reports for automation purpose using Base/SAS and Macros.
  • Administration activities using SAS Management Console.
  • Interacting with the business users regularly

Tableau Developer Activities:

  • Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development life cycle.
  • Experience in Marks, Publisher and Security concepts.
  • Experience with creating Worksheets and Dashboard.
  • Working with Multiple data Connections.
  • Experience with troubleshooting and Tableau Analysis.
  • Experience in tableau created Rapid Analytics and Reporting.
  • Experience with Tableau for Data Acquisition and data visualizations for client and customers.
  • Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
  • Involved in Custom Geocoding.
  • Created the Test Evaluation and Summary Reports.
  • Experience in BI interactive Dashboards and Tableau Publisher.
  • Experience of Client-Interaction on onsite/Offshore.

Environment: Tableau 6.0, Windows 2008 server, Tableau Desktop, Tableau Server, SQL, Oracle 10g. SAS 9.3, SAS Management Console 9.3, SAS Grid Manager, SAS Enterprise Guide 5.1

Confidential

Statistical Programmer

Responsibilities:

  • Coordinate with managers/lead programmers from other locations for resource/project planning.
  • Worked in different therapeutic areas like Immunology, Urology, Infectious disease, Respiratory, Cardio- vascular and Oncology.
  • Experience in writing specifications for generation of SDTM, ADAM standard compliance datasets and analysis datasets.
  • Adopted quickly with different working environments.
  • Reviewed the specifications for generation of SDTM mapped datasets.
  • Developed SDTM, ADAM datasets from raw datasets.
  • Extensively involved in generation of reports, exception reports, edit checks etc.
  • Coordinate and participate in the programming and validation of analysis datasets, tables and listings.
  • Developed standardized macro for descriptive statistics, alignment of the values and giving page numbers in the tables which in turn reduced the time for generation of tables.
  • Responsible for the coordination, creation and maintenance of Statistical Programming project documentation.
  • Involved in review of the specifications for tables and listings.
  • Performed Unblended Randomization activity for blinded studies.
  • Worked on pooling of information from different studies for ISS and ISE submissions
  • Actively participated in presentation of newly learnt topics in the Knowledge sharing sessions.
  • Produced reports in PDF and RTF format by using SAS ODS.
  • Mentor newly joined colleagues to get acquaint with the new system and policies.

Environment: SAS 9.2/9.3, SAS/BASE, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS/STAT, Excel/Access-2000, SQL, Windows 2000/NT.

Confidential

SAS Developer

Responsibilities:

  • Closely working with narrative writers to provide information about patients having adverse events.
  • Identifying subjects for whom CRFs need to be compiled and scanned for a regulatory submission.
  • Developing Auto-generated Narrative documents in SAS.
  • Converting datasets into word documents by using Mail Merge concept.
  • Creating list of subjects in Excel format for whom narratives need to be written for particular study’s cut of data.
  • Extensively used Ultra-edit to execute SAS programs along with Interactive SAS.
  • Creating analysis dataset for quality check of SDTM datasets.
  • Developed analysis datasets from raw or SDTM datasets to monitor the safety data to limit the risk.
  • Extensively generated tables and listings using PROC REPORT as per the mock shells given in the SAP.
  • Extensively worked on pooling of information from different studies.
  • Peer Reviewing of the tables and listings generated by my team members to find mismatches if any before submitting to the client.
  • Produced reports in PDF and RTF format by using SAS ODS.
  • Extensively worked on ad hoc reports requested from SDTM and clinical data management team.
  • Actively participated in giving presentations to team and also to clients.

Environment: SAS 9.1, SAS/BASE, SAS/ACCESS, SAS/CONNECT, SAS/GRAPH, SAS/STAT, Excel/Access-2000, UNIX, SQL, Windows 2000/NT.

Hire Now