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.
• 4 years of experience in Data warehousing and Business Intelligence technologies along with strong experience of data visualization using Tableau.
• Hands on experience on Tableau 8.0/8.2/8.3/9.0 and Tableau Reader in Health care, Finance and Insurance domain.
• Extensive Tableau Experience in Enterprise Environment and Tableau Experience including technical support, troubleshooting, report design and monitoring of system usage.
• In - depth knowledge on Tableau Desktop and Tableau Server.
• 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.
• Built interactive dashboard using techniques like guided analytics and visual best practices provided by Tableau.
• Worked on Tableau administration tasks such as publishing workbooks, setting permissions, managing ownerships, working with Sites, providing access to the users and adding them to the specific groups and Projects, Scheduling Refreshes and Subscriptions in Tableau Server.
• MS-Business Intelligence experience using SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• 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 Desktop/Server 9.0/8.3/8.2/8.1/8.0/7.0 , SAS 8.2/9.1.3, SAS/BASE, SAS/STATSAS/GRAPH, MS BI (SSIS, SSRS, SSAS), SAP BO

Database Applications: MS SQL Server, Hadoop, Oracle 9i/10g, SAP BWProgramming Languages SQL and PL/SQL, HTML, C#Operating System Windows 2000, Windows XP, Windows 7, UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis

Tableau Administrator/Developer

Responsibilities:

• Served as Tableau subject matter expert to assist the BI team in learning Tableau, addressing development roadblocks, and migrating reports from existing server to new Tableau enterprise server.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau Development life cycle.
• Administer and support a multi-tier Tableau Infrastructure include upgrade analysis and planning, security administration, release management, troubleshooting, performance tuning, and general system maintenance.
• Assist business users with certification trainings for self -service BI, which allows them to leverage the benefits of the tool and explore data themselves.
• Help the BI team plan/implement a Tableau community of practice by providing ideas/insights and best practices.
• Assist users with Tableau development, suggested enhancements to developed reports, and publishing reports to the server with security settings.
• Assist with Tableau server administration, security configuration including setting up AD user groups, permissions, security roles.
• Creating active directory groups, importing them to Tableau server, syncing the groups on daily basis.
• Publishing the reports on server, scheduling workbooks, data sources on server.
• Embedding reports on BI Marketplace which is a common platform to share reports to end users.

Environment: Tableau Desktop & Server 9.0/8.3/ 8.2/8.1 , MS SQL Server, Oracle.

Confidential, Detroit, MI

Sr Tableau Developer

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 ofTableauplatform 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, HDFSMap 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:

• 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
• 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, SQLOracle 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/STATExcel/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.