Career Summary

Over 8+ years of experience in Business Intelligence and Data Analysis with 4 years of experience as Tableau developer. Expertise in Report Design, Dashboard development using Tableau, and SAS Reporting. Knowledge on Business Intelligence/Business Analytics software like SAP BO, MS BI (SSAS, SSRS) and Data warehouse Concepts.

Business Intelligence Skills:

• Extensive Tableau Experience in Enterprise Environment and Tableau Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.
• 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.
• 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.
• MS-Business Intelligence experience using SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• Expert in ETL-Extraction Transformation Loading, Data warehousing, Operational Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Building reports by connecting against Single Table, Multiple Tables and Custom SQL.
• Highly proficient in the use of SQL and PL/SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Good Independent / team working skills and experiences, excellent communication skills with very good customer handling capabilities.

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, MS BI (SSIS, SSRS, SSAS), SAP BO

Database Applications: MS SQL Server, Hadoop, Oracle 9i/10g, SAP BW,

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

Roles and 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

Roles and 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

Confidential

Statistical Programmer

Roles and 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

Roles and 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.