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.