SUMMARY:

• Confidential is a Certified Tableau Developer having 8+ years of experience in Software Design, Development, analysis, testing, Data warehouse and Business Intelligence tools.
• Experienced in Data Visualization, Data Analysis, Business Intelligence, IT Analysis/Design, and Client/Server System Architecture.
• Hands - on with creating solution driven views and dashboards by developing different chart types including Heat/Tree/Geo Maps, Line/Bar/Pie Charts, Scatter Plots, and Bullet Graphs in Tableau Desktop versions 6, 7, and 8.1.
• Utilized all Tableau tools including Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public.
• Build better dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of projects.
• Built and expanded reports available for both internal support and external customer reports, which included increasing the scope of data extracted and better utilization of reporting.
• Experienced in troubleshooting and performance tuning of reports and resolving issues within Tableau Server.
• Experienced in Tableau Server administration including setting up Active Directory users and groups, giving appropriate permissions for viewing published dashboards and scheduling data refresh instances.
• Recommend OS configuration to end-client and provided walk-through process on installing Win Server 2012 R2, Tableau Server, and SQL Server 2012 R2 during Business Intelligence road-map and proof of concept project.
• In depth knowledge of Software Development Life Cycle (SDLC).
• Strong analytical, logical, Communication and problem solving skills and abilityto quickly adapt to new technologies by self-learning.
• Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn on the fly.
• Excellent communication skills in both written and oral along with ability to tell a story through data.
• Ability to interact professionally with a diverse group including executives and managers.

TECHNICAL SKILLS:

Specialties: Data Visualization, Business Intelligence (BI), Data mining andData Analysis

BI Tools: Tableau Desktop, Tableau Public, Tableau Reader, Tableau Online, Tableau Server(V 7.x/8.x),Cognos 8.4

Relational Database: MS SQL Server, Oracle, Teradata, DB2, MS Access

Tools: and Packages: SQL Server Management studio, Toad, Profiler, Microsoft Visual Studio,Microsoft Office, MS Visio, Erwin

Languages: SQL, PL/SQL, C, C#, Java, HTML, XML, XSL

Operating Systems: Windows 2000/2003,2008 Server, Windows 95/98/2000/XP/7, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

TABLEAU/BI DEVELOPER

Responsibilities:

• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axes bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Extensively used data blending in Tableau.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Created report schedules, data connections, projects, groups in Tableau server.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in creating reports as per user requirements using MS Reporting Services 2005/2008R2.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQLIndex, Views, Complex Stored Procedures, triggersand appropriateUser defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Server v7/v8, Tableau Desktop v7/v8, Windows Server Standard R2, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2, UNIX, Linux RHEL 5.4.

Confidential, Columbia, MD

TABLEAU/BI DEVELOPER

Responsibilities:

• Involved in Proof of Concepts (POC) presentation and review with project and IT lead along with developingTableauDashboards.
• Worked on technical strategy, provided hardware and software configuration, understood client-wide BI implementationproject, design and develop visualizations.
• Adjust views/dashboards after initial POC presentation.
• Brainstorm ideas onwhattoinclude in views/dashboards from the data sourceand document on the fly business requirements.
• Create views and dashboards on end client'ssales data. Producepowerful dashboards telling story behind the data in an easy to understand format such as pie, bar, geo, and line charts that are viewed daily.
• Cleanse and normalize data in MS Excelby combining from variousdatasources.
• PerformTableauServer admin duties; add users/groups from Active Directory; and schedule instances inTableauServer including weekly data dump.
• Train endclient users onTableauDesktop by providing step-by-step guidancefrom basics to advanced functions ofTableauincludingworking with calculations,parameters, and date functions.
• Involved in migration of Cognos adhoc reports to Tableau workbooks.

Environment: TableauDesktop 7.0/8.1,TableauServer 7.0/8.1, Cognos 10.1, MS Excel, MS SQL Server 2012 R2, Win Server 2012 R2, Active Directory

Confidential, Columbus, OH

DATA/BI ANALYST

Responsibilities:

• Involved in reviewing requirements and data sources form MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Using Tableau Desktop created Interactive-reporting dashboards by combining multiple views.
• Review Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Published views and dashboards in Tableau Server for auditor review.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop V 7, Tableau Server, Oracle, SQL Server, MS Excel, MS Access, Win Server 2008 R2, Active Directory

Confidential, Columbus, OH

BUSINESS SYSTEMS ANALYST

Responsibilities:

• Gathered and analyzed both legal and credit data sets, performed due diligence on deals, consulted with credit associations and business representatives, and financial ratios for the preparation of credit reviews.
• Translated clients’ needs into usable mapping and coding instructions and created functional requirements document and mockups for reporting.
• Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Developed and maintained reporting using in MS Excel queries and SQL. Produce performance reports and implement changes for improved credit reporting along with performing conditional formatting for data analysis.
• Created Test Cases, Activity Diagrams, and System Flow Charts.
• Reviewed request to determine basic characteristics, such as origin and report flow, mapping, format, frequency, distribution, and purpose or function of report.
• Worked closely with the Information management groups to develop, test, and validate systems and reports, attended meetings with users and IT, documented business, technical, and systems requirements.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.

Environment: MS Office (Word, Excel, Power Point), RUP, Share Point, MS Visio, HP ALM, Tortoise SVN

Confidential, Livingston, NJ

BUSINESS/DATA ANALYST

Responsibilities:

• Evaluated annual credit reviews for a portion of CIT Bank’s portfolio and recommended analyzed data to Credit Committee for appropriate credit risk rating decisions.
• Gathered and analyzed both legal and credit data sets, performed due diligence on deals, consulted with credit associations and business representatives, and financial ratios for the preparation of credit reviews.
• Translated clients’ needs into usable mapping and coding instructions and created functional requirements document and mock ups for reporting.
• Prepared Business Requirement Documents (BRD's) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Developed and maintained reporting using in MS Excel queries and SQL. Produce performance reports and implement changes for improved credit reporting along with performing conditional formatting for data analysis.
• Created Test Cases, Activity Diagrams, and System Flow Charts.
• Reviewed request to determine basic characteristics, such as origin and report flow, mapping, format, frequency, distribution, and purpose or function of report.
• Worked closely with the Information management groups to develop, test, and validate systems and reports, attended meetings with users and IT, documented business, technical, and systems requirements.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.

Environment: MS Excel, Oracle SQL Server, UAT, BRD, FRD, SQL Queries, Flow Chart

Confidential

BUSINESS/DATA ANALYST

Responsibilities:

• Participated for the creation of Functional Requirement Document (FRD) and Business Process Workflow with Stakeholders.
• Worked with stakeholders on Joint Application development (JAD) during prototyping phase of SDLC.
• Involved throughout the business System Development Life Cycle (SDLC).
• Worked with SCRUM Project Management and Agile Methodologies for Software development Life Cycle.
• Conducted GAP analysis of the different reports that are being presented to clients to accommodate their requirements for the new enhancements.
• Utilized Rational Unified Process (RUP) to configure and develop process, standards, and procedures.
• Facilitated JAD sessions with model diagrams to elicit future state business requirements and to document Business Use Case To-Be artifacts.
• Created SQL scripts to validate the inputs.
• Worked with QA team to develop performance test cases based on projected user load.
• Involved in all stages of testing process - Development of Test scripts and Test cases based upon requirements for Functional Testing, Integration Testing and support for User Acceptance Testing.
• Used Rational tools to document and manage requirements, enhancement requests, and other documentation issues for the application.
• Worked with management to create and communicate critical information to the user community via email and discussion boards.

Environment: MS Office (Word, Excel, Power Point), RUP, Share Point, MS Visio, Microsoft Outlook