PROFESSIONAL SUMMARY:

• Over 10 years of experience in Database and Data Warehouse Applications Developing along with Business Intelligence technology and Data Visualization usingSAS and Tableau.
• Hands on experience in creating workbooks and dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9.0/8.2/7.
• Strong Expertise in using Tableau software as applied to BIData analytics, reporting and dashboard projects.
• Extensive Experience in various Tableau Desktop Reporting Features like Measures, Dimensions, Folder, Hierarchies, Live/Extract, Filters, Table Calculations, calculated fields, Sets, Groups, Parameters, Forecasting, Blending and Trend Lines.
• Extensive knowledge in various reporting Objects like facts, Attributes, Hierarchies, Filters, Sets, Groups, Parameters in Tableau.
• Combined reports & views into interactive Dashboards in Tableau desktop and presented to Program Managers, Business users and End Users.
• Expertise in design & development of various Reports and Dashboards using various Tableau Visualizations like Dual Axis, Bar Graphs, Box & Whiskers Plot, KPI Scorecards, Scatter Plots, Pie - Charts, Heat Maps, Gantt Charts, Bubble Charts, Tree Maps, Funnel Charts, Box-Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to business requirements.
• Worked extensively onData blending, and different table calculations for different scorecards, Performance Tuning Tableau Reports, published dashboards on Tableau Public.
• Proficient in Oracle and SQL Server on Windows platforms. Experience in Database Modeling, Dimensional Modeling andData Analysis. Design, development, maintenance, testing, performance monitoring and performance Tuning, Troubleshooting,Unit Data migration etc.
• Proficient in preparing Presentations, Graphs, Pivot Tables using Microsoft Excel and PowerPoint.
• Developed effective and interactive Dashboards using Parameters and Actions.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Having Good Experience inData Warehousing Concepts andData Modeling Techniques like Dimensional Data Modeling, Snow-Flake Modeling, Star Schema Modeling, OLTP and OLAP.
• Extensive experience working in Windows, UNIX, LINUX, OS X.
• Proactive team player with capability of handling responsibilities independently as well as in a team environment and displayed strong analytical, problem-solving skills and document function/process flows.
• Excellent ability to work independently and as a part of a multi functional geographically diverse team.
• Run Base,SAS/Access,SAS/STAT,SAS/Graph,SAS/STAT,SAS/DI studio and SAS/EG.
• Capable of processing large sets of structured, semi-structured and and unstructured data supporting systems application architecture.
• Able to assess business rules, collaborate with stakeholders and perform source-to-target data mapping, design and review.
• Familiar with data architecture including data ingestion pipeline design, Hadoop information architecture, data modeling and data mining, machine learning and advanced data processing. Experience optimizing ETL workflows.
• Knowledge on Ecosystems like Hive, Pig, Sqoop, Map Reduce, Flume, Oozie, Spark and capturing data from existing databases that provide SQL interfaces using Sqoop.
• Develop and Modify predefined Macro applications
• Extensive experienced in coding to create list tables, Cross tab, chart and plots using SAS/BASE, Graph and ODS and optimizing programs by using advanced SAS Programming techniques for development.
• Experienced in producing detail and summary reports using PRINT, REPORT, MEANS and SUMMARY procedures
• Extensive experience in working with Base SAS (MACROS, Proc SQL, ODS), SAS/ACCESS, and SAS/GRAPH in Windows, and Mainframe environment
• Experience in working with multiple databases like Oracle, DB2 and Teradata
• Experience in development of documentation like Technical Specifications from BRD and Process/Program flow
• Thorough knowledge in SAS Programming, using Base SAS, Macro Facility, Proc SQL, SAS Procedures, SAS Functions, SAS Formats, and ODS facility in data scrubbing, manipulation, and preparation to produce summary datasets and reports
• Have very good knowledge on Health Care Insurance domain and statistics.
• Involved in all phases of Project Life Cycle.
• Expertise on various BI Suite tools like: SAS Enterprise Guide, SAS DI,SAS Management Console, SAS Stored Process Server, SAS Web Report Studio (WRS) and SAS Information Delivery Portal.

TECHNICAL SKILLS:

BI & Reporting: Tableau (Desktop, Server, Report, Public), SAS.

Data Modeling: Relational Modeling and Dimensional Modeling, Star Schema, Snow Flake Schema, Fact and Dimensions tables, Entities, Attributes, MS Visio.

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2012/2008, Teradata, MS access.

Languages: SAS,R Programming, UNIX Shell Script

Environment: s: Windows Family, UNIX (Sun Solaris, AIX)

Office Applications: MS Office 2013/ 2010/2007/2003.

PROFESSIONAL EXPERIENCE:

Confidential

SAS/Tableau Consultant

Responsibilities:

• Deliver ad-hoc and production reporting on an as needed basis. Automation of the process wherever is possible
• Coordinate with the Business team to conduct internal checks, controls and analysis provide RWA variance explain and change in RWA analysis. managing the calculation, consolidation, reporting and explain of Market Risk RWA.
• Review the test results before sending it to client.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume ofData.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Used Trend Lines, Lines and Annotations to describe theData.
• CreatedData extracts for better performance and accessingData offline.
• Used parameters and input controls to give users control over certain values.
• ImplementedData blending with multipleData sources on a single worksheet forData analysis.

Confidential

SAS/Tableau Consultant

Responsibilities:

• Automating manual process and optimized existing programs.
• Interact with the Business subject matter experts and determine business questions and data requirements.
• Developed new QBR reports based new data and also worked on enhancement of existing QBR reports.
• Improve operational efficiency by automating and integrating programs and increased reusability
• Review the test results before sending it to client.
• Designed and publishing visually rich and intuitive Tableau dashboards for executive decision making.
• Created Sets, Groups andData Bins as per user requirements.
• Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.
• Provided visual/graphic analysis based onData content.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Implemented new features in Tableau 8.2 to the existing workbooks and dashboards.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume ofData.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Used Trend Lines, Lines and Annotations to describe theData.
• CreatedData extracts for better performance and accessingData offline.
• Used parameters and input controls to give users control over certain values.
• ImplementedData blending with multipleData sources on a single worksheet forData analysis.
• Created and Published Tableau Dashboards into Tableau Server

Confidential

SAS/Tableau Consultant

Responsibilities:

• Understand the reporting requirements and provide Tableau reporting solutions.
• To develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Combined visualizations into Interactive Tableau Dashboards and published them to the web portal.
• Used forecasting feature to provide predictive information to model future based on the past history which added value to our project.
• Developed metrics, attributes, filters, reports, dashboards and also created advanced chart types, visualizations and complex calculations to manipulate thedata.
• Used and combined different reports to analyze and compare the sales of the products which were sold during a period of time. This will make the companies grow their business.
• Created visually compelling and actionable interactive reports and dashboards.
• Design and development of interactivedata,data visualizations, graphical dashboards and reports using Tableau.
• Created individual Worksheets and incorporated it into Dashboards with the appropriate filters.
• Created the calculated fields and parameters along with the appropriate filters and plotted the measures on the respective graphs with the basedata.
• Documentation, Maintenance and Scheduling.
• Created Context filters on the existing filters and Tableaudata extract to publish it in server by optimizing it to reduce the report rendering time.
• Created actions to navigate to various pages as per the user wish.
• Created summarized menu options as tabs in home page where the users easily choose the required options.
• Involved in reviewing business requirements and analyzingdata sources from Excel/SQL Server for Design, Development, Testing, and Production rollover of reporting and analysis projects within Tableau Desktop.
• Blendeddata from multiple databases into one report by selecting primary keys from each database fordata validation.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Environment: Tableau Desktop 9.0/8.2, Tableau (Reader, Public, Server), SQL Server, MS Excel, Oracle 11g, Microsoft office 2010, Windows 2010/07, Microsoft Access 2010/2007/2003.

Confidential

BI/Tableau Developer

Responsibilities:

• Going through Report Specification Documents and Understanding the User requirements.
• Maintained/Enhanced existing Dashboard reports.
• Created and used Filters, Quick Filters, Table Calculations and Parameters on Tableau reports.
• Created of dashboards for business groups like finance and sales.
• Data extraction, creation of calculated fields, calculated measures, filters, sets, parameters and bins and action filters.
• Designed and publishing visually rich and intuitive Tableau dashboards for executive decision making.
• Created Sets, Groups andData Bins as per user requirements.
• Created various views in Tableau like Tree maps, Heat Maps, Scatter plots, Geographic maps, Line chart, Pie charts and etc.
• Provided visual/graphic analysis based onData content.
• Generated Interactive Dashboards with Quick filters, Parameters and Actions to handle views more efficiently.
• Implemented new features in Tableau 8.2 to the existing workbooks and dashboards.
• Developed various dashboards, used Context filters, Sets while dealing with huge volume ofData.
• Created views using various axes like Individual Axes, Dual Axes and Blended Axes.
• Used Trend Lines, Lines and Annotations to describe theData.
• CreatedData extracts for better performance and accessingData offline.
• Used parameters and input controls to give users control over certain values.
• ImplementedData blending with multipleData sources on a single worksheet forData analysis.
• Created and Published Tableau Dashboards into Tableau Server.
• Writing SQL queries forData validation by using join conditions.

Environment: Tableau Desktop 8.2/7, Tableau Server/Reader, Oracle, Windows 2007/ XP, SQL 2008, Microsoft Excel 2008, Microsoft office 2008, MS Visio.

Confidential

SAS Developer

Responsibilities:

• Requirement gathering and understanding the specs.
• Task Estimation and develop frame work for reporting.
• Preparing safety summary results with tables, listings, graphs and reports using SAS BI tools including WRS, Portal.
• Providing technical assistance to the team. Review the assigned tasks of the team.
• Verifying the test result by checking the Actual result with the expected result reviewing the test results before sending it to client.
• Involve in production implementation activities.
• Post production jobs monitoring.

Confidential

SAS Developer

Responsibilities:

• Understanding scientific data across clinical documents
• Documenting the development plan and Quality check steps
• Query and Analyzing the data from information warehouse
• Data preparation
• Data cleaning and validation
• Creation and modification of relevant attributes
• Aligning the attributes position, naming convention, label and formats
• Creating the final report with client specification formats
• Quality checks
• Steps are followed as per development plan
• Code standardize and annotation
• Check/uncheck the Quality check documents by monitor the logic, constrains, attributes position, naming convention, label, formats etc…
• Codes and results are followed as per Quality standards then sharing to clients through SharePoint.

Confidential

SAS Developer

Responsibilities:

• Access remote files by using Filename statement, FTP Access Method.
• Count the number of observations based on line of business and other key variables
• Creating required datasets by using extracted data based on different products and markets.
• Calculating disruption frequencies based on line of business by using Freq applications.
• Calculating frequencies based on referral codes.
• Combine different data sets by using Merge or join Statement.
• Calculating Descriptive statistical results
• Generating alerts based on UCL and LCL values.
• Involve in production implementation activities.
• Writing Automated Email generation code in SAS to receive the alert information.