SUMMARY:

• 7.5+yrs. - Partnering with Business users on the Visualization initiatives - including Design, Development & Testing of Tableau Reports, SAS , Data Analytics / Modeling, SQL and UML
• 8 yrs. experience in Internet & Office applications, Backup utility and Configuration Management
• Interacted daily with Business Analysts, Data Modellers and defined mapping documents and design processes for various sources and targets
• Analysed user and business requirements & attended periodic meetings for changes in the application requirements and documents
• Enhanced the organization’s capability to analyse and derive insights from large sets of data by driving best practices, standards, change management and analytical understanding across HR and Confidential
• Developed business & technical requirements, technical design and UI mock up documents
• Leading Business Workshop sessions: Understanding Business KPI’s, Developing User stories, Clarifying & Validating the business need, translating in to high level BI designs & Estimation
• Developed Dashboards and story points using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau
• Developed various advanced interactive visualizations such as Heat map, Bubble chart, Tree map, and Line charts while working on motion chart, & Drill down analysis in Tableau Desktop
• Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, grouping, live connections and in-memory in TABLEAU
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and TABLEAU
• Defined best practices for Tableau report development and effectively used data blending features in tableau & provided operational support to existing Development team on all Tableau user related activities
• Identified trends and performed quality check to ensure accuracy by tracking multiple data sets at once, speeding up the discovery phase, planned stabilizations and phased deliverables
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository
• Provided 24/7 customer support to tableau users

TECHNICAL SKILLS:

Software: Tableau(v9.1), SAS Enterprise Miner, IBM Cognos, T-SQL, SQL Server Management Studio, Hadoop, Hive, MicroStrategy, Netezza, Toad, WEKA, RStudio, SAP NetWeaver, Adobe Photoshop, MS Office (Word, Excel, PowerPoint), MS Access, MS SharePoint, HTML 5

Development/Testing Tools: Visual Studio, Notepad++, JUnit

Language: R, SQL, UML, SDLC, C++, JAVA, CSS, JavaScript, JQuery, PHP

General Skills: Backup/Restore Utilities, Configuration Management, Help Desk, Support, Troubleshooting

Operating Systems: MS DOS, Windows 95/98/NT/2000/XP/Vista/7/8/10, Unix

PROFESSIONAL EXPERIENCE:

Sr. Tableau Developer/Data Analyst

Confidential, San Jose, California

• While working on the CPM analytics team developed User Stories, conducted data analysis and data compilation on an activity book with over 18 million loans with over 48 attributes amounting to $92 Billion using UnixSAS(v9.2) and Toad for Oracle(v12.1.1)
• Interacted with business users to understand and document their key reporting requirements ; translated those into reports and interactive dashboards for stakeholders
• Collected functional and non-functional requirements from users, customers and stakeholders using a variety of common techniques
• Developed delinquency by location report in Tableau using a combination of charts and maps and delinquency over time report using line chart to present the trend analysis
• Interacted with the team lead and Biostatistician for queries regarding client specifications, comments, QC issues, ad-hoc programming and for submitting data management issues
• Designed and developed navigation report and risk loan analysis report using action, context filters and calculated fields
• Designed and developed percentage of delinquent balance report by creating new calculated fields, creating new parameters, bar and area charts
• Designed/converted the modifications loans performance packet report which consisted of 6 different types of reports based on loan types from spot fire to tableau from scratch
• Projected and forecasted future risk in terms of number of seriously delinquent loans by developing area maps to show details at the county level
• Blended data from multiple data-sets by using linking feature in Tableau Desktop
• Developed dashboards to easily visualize KPI’s by exploring the data from multiple data sources & created HTML, RTF, PDF reports using SAS/ODS
• Developed various advanced interactive visualizations such as Heat map, Bubble chart, Tree map, and Line charts in Tableau Desktop
• Managed the PMC ( Post Modification Counselling ) and monthly trial conversion reporting process by modifying the existing SAS code, generated Tableau reports, identified trends and performed QC analysis for the same
• Assisted in preparing new job aids for a portfolio of 8 monthly reports and modified 5 existing ones to meet new company standards using Microsoft Word
• Created and automated the process of publishing daily delinquency reports using Tableau(v8.2) and uploaded them to the oracle database
• Created various Ad-hoc reports, performed analyses as per user requests for managerial meetings and discussions and converted metric insight reports to tableau reports
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint

Tableau/SAS Developer

Confidential, Dallas, Texas

• Conducted Business User Workshops, data analysis and data compilation for ‘Enterprise Find Me Follow Me’ (Efmfm), an innovative and interactive real time tracking solution for delivery vehicles using SAS
• Gathered visualization requirements, created new prototypes and recommended changes to existing reports
• Created awareness amongst the technology team on how tableau assists in exploring data and providing insights
• Generated the test plan specifying an overview of testing approach, testing strategy, roles, responsibilities and its scope
• Assisted in preparing Business Requirement Documents (BRD) and documented software requirements for the application
• Developed relationships and processes with sales, finance, HR, sales operations, and other functional teams to identify and address reporting issues
• Managed and developed financial reports that aligned and simplified monthly business reviews, annual planning, and forecasting processes
• Performed Parallel Testing or Production Testing, which ensures that the new system will perform correctly in a production environment and interface correctly with other production systems.
• Participated in the User Acceptance Warranty Testing. Involved in doing security and negative testing of the application
• Generated ad hoc and monthly recurring financial and operational performance analysis, based on the needs of the stakeholders
• Applied subject matter expertise and advanced level of understanding of best practices and standards of using Tableau
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Created technical documentation and presented information to senior management
• Partially involved in all phases (SDLC) of this project from planning, requirement gathering, designing, development, testing and implementation
• Created Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Indicators (KPI) and Measure
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers
• Created organized, customized analysis and visualized projects and dashboards to present to senior level executives
• Created various Ad-hoc reports and analyses as per user requests for managerial meetings and discussions
• Performed Data validation on updated raw data as and when required
• Responsible for data mapping of raw datasets according to data standard

Tableau/ SAS Developer

Confidential, Illinois

• Worked directly with customers to develop business insights through Visualization initiatives
• Compiled detailed reports using tableau, provided helpful insights and made recommendations to the stakeholders
• Documented workflows for various product modules based on stakeholder interviews and review sessions
• Performance tuning of existing migration code to finish migration task in much less time. Used bulk collections, hints and indexes to improve the performance
• Played key role in enhancing client's Web reporting system, reducing time of delay financial tracking analysis by 30%
• Drove needs analysis and gap assessments to develop, design and deliver solution options
• Wrote, maintained and supported a variety of complex reports and queries utilizing appropriate date reporting tools
• Created Table of Contents (TOC), a common navigation page which had all the links to various reports
• Managed maintenance and support of 32 payment interface applications & resolved multiple customer impacting P1 issues and performed root cause analysis with 100% SLA
• Developed static and dynamic parameter files for reusability and database connection management among development/testing/production environments
• Developed reports with features like drill down, slice and dice, master/detail for analysis of business using Tableau
• Resolved technical problems related to automated systems, performed analysis, developed and implemented test plans and solutions &provided training for end users for generating their own complicated report
• Worked on migration of user developed applications/reports from mainframe SAS to SAS EG in order to optimize the execution time, resources and to reduce the cost of process