SUMMARY

• Over 7+ years of experience in providing innovative solutions in Banking, Healthcare, Insurance and Retail business processes.
• Extensive Tableau Experience using Tableau 10.x/9.x/8.x/7.x as a Developer and Analyst.
• 5+ years of extensive Tableau Experience using Tableau 10.x/9.x/8.x/7.x as a Developer and Analyst.
• Rich experience working in Integration, Migration and Business Process Re - engineering of complex projects from old legacy systems.
• Extensive experience in Tableau Desktop/ Tableau Server, creating highly interactive Data Visualization Dashboards using feature such as Data Blending, Extracts, Calculations, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures etc.
• Expertise in developing Reports / Dashboards with different Analytics Views (Drill-down / Dynamics, Cascading style sheets, Pivot table, Chart, Column Sector) using Presentation services.
• Creation of Alteryx workflows for data blending, correction, and preparation for reports. Data visualization via Tableau Desktop. SharePoint site administration for report distribution in combination with Tableau Reader.
• Proficient in analysis, design and implementation of data warehousing/ BI solutions using Tableau, Alteryx, Informatica, MicroStrategy, Tableau and Database technologies.
• Highly proficient in Agile, Test Driven, Iterative, Scrum and Waterfall Software Development Life Cycle (SDLC).
• Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data.
• Expertise in data base programming (SQL, PLSQL, TSQL) MS Access Oracle 10g/9i, SQL server 2005/2008, DB2, Data base tuning and Query optimization.
• Hands on experience in Teradata SQL, Tools & Utilities (Fast Export, MultiLoad, FastLoad, Tpump, BTEQ and QueryMan).
• Provided Knowledge transfer (KT’s) to the team back in Offshore and client service managers.
• Excelled in performance at different client locations with the interactive dashboards presentations.
• Developing reports using PowerBI
• Excellent problem solving and analytical skills with a proven ability to learn and understand new technologies efficiently.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good noledge on SQL Server Analysis Services (SSAS).
• Doing Tableau Installation, Configuration, upgrading and licensing.
• Competence to adapt to new software applications and products, self-starter, with excellent communication skills and understanding of business workflow.
• Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS

Project Management: MS Project, MS Office Suite, SharePoint, H, HPSC Change management, ServiceNow

Business /Data Modeling: UML, Erwin 7.2/4.0, EmbarcaderoER/Studio, MS Visio, Rational Rose, Power BI

Methodologies: Rational Unified Processes, Agile-Scrum, Waterfall, Lean, SixSigma

Requirement Gathering: Rational Requisite Pro, DOORS

Tools: HP Quality Center (QC), TFS, Bugzilla, Velocity 7.6 (POS), VQ manager, Report center, dab Jira, POS analysis, MS Office, Toad, Auto sys, Putty, SAP MM, JIRA

Operating Systems/DB: Unix, MVS, AS400, Windows 98/2000/XP/Vista/7

OLAP / BI Tools: SAP Business Objects BI Platform 4.1, Business Objects XI R3, Crystal Reports 4.0 (1993) through SAP Crystal Reports 4.1 2013 (Authorized Crystal Engineer), SAP Universe Designer, SAP Web Intelligence, SAP Analyzer, SAP Xcelsius, Microsoft SSIS, SSAS,SSRS, MicroStrategy.

ETL Tools: Informatica 7.0,8.0,9.0,10.0. SQL Server DTS Packages, SSIS 2005/2008

Database: SQL Server 2008 R2, Oracle, Teradata, DB2, MySQL

PROFESSIONAL EXPERIENCE

Confidential, Jersey city, NJ

Sr. Tableau Admin/ Developer

Responsibilities:

• Upgraded Tableau 8.3 to Tableau 9.x and 10.1 and gathered requirements, chalked dashboard development plans from raw data and interacted with Data Warehousing team regarding database design.
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in Tableau
• Managed Tableau extracts on Tableau Server and administered Tableau Server
• Involved in understanding the reporting requirements and providing Tableau reporting solutions.
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau.
• Extracting the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an input to Tableau.
• Experience to work with senior management to identify strategic goals, objectives, scope, budgets and process for internal and external development to manage risk analysis and mitigation plans, status reports, and client presentations
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• 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
• Developed and published interactive reports, also scheduled reports using Tableau Server.
• Publishing the developed reports to production Tableau server environment.
• Created extensive integration of data and joins for data blending from different data sources
• Developed in-depth Dashboard Drill Down and Links to interrelated performance metrics
• Worked with various infrastructure teams and Tableau support team to halp improve dashboard response time.
• Collected data on various process measurements and formatted into graphs using Tableau Software.
• Performed User Acceptance Testing to ensure that developed systems satisfied needs of business clients

Environment: Tableau Desktop 8, 9.1,10.3, Tableau Server 8.0, 9.1,10.0, MS Office Suite, Teradata, Oracle, Alteryx, SQL Server, MS Excel.

Confidential

Tableau Developer / Data Analyst

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Gathered Business Requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Prepared BI Interactive Dashboards using calculations, parameters inTableau.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Deep experience with the design and development ofTableauvisualization solutions.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
• Configured different data sources using Tableau Desktop
• Created best visualizations reports as per the business requirements using Tableau desktop professional edition.
• Blended data using multiple data sources (primary and secondary).
• Expertise in Tableau Actions used to navigate between sheets or URLs, highlight or filter.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Extensive experience on creating trend reports including forecast and trend lines.
• Configured incremental data refresh for the data sources.
• Good working noledge on Tableau administration for creating users, groups, sites and access control.
• Involved in migration activities related to Tableau across the environments.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Implemented security in reports according to employee groups and roles according to the requirement and was involved in deployment process.
• Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environment: Tableau Desktop/Tableau server, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft Office.

Confidential, Hollywood, CA

Tableau Admin/ Developer

Responsibilities:

• Identifying and gathering user requirements and business requirements from different groups, end users for developing reports
• Designed and developed Tableau Dashboards for critical Projects, OBIEE to Tableau Reports Conversion.
• Performing yearly analysis and business risks using different line charts.
• Creation of ER diagrams and database design for the project.
• Handled Tableau admin activities granting access, managing extracts and Installations.
• Creation of Tableau users and testing with different security levels for web authorization and autantication.
• Exploring tableau 8.0 features for web editing and authoring, filters and server monitoring.
• Created Tableau scorecards, dashboards using various plots (stack bars, bar graphs, scatter plots) demonstrating key information for decision making.
• Created conditional and context filters to filter the data on dashboard. Responsible for Creating Parameters for desired functionality.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle, and SQL Server.
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, and Background images, Maps, Trend Lines and Statistics.
• Created Groups, hierarchies, and Sets to create detail level summary reports and dashboards using KPI's.
• Generated tableau dashboards for sales with forecast and reference lines.
• Build and publish Tableau reports utilizing Data Blending, multi-level hierarchy, Table Calculations, Parameters, Graphs and Actions.
• Tableau advanced charts using geo maps, Gantt charts, Pareto charts, scattered plots for providing multidimensional views.
• Key integration with web applications and resolving ticketing server issues with IIS.
• Smoke testing for all the business scenarios in Dev and Pre-Production servers.
• Integration of tableau reports with web application and viewing reports online.

Environment: Tableau Desktop/Server 7/8, OBIEE, Oracle 10g, SQL, Clear Quest (CQ), Informatica, ER Studio.

Confidential, Pittsburg, PA

Tableau Admin/ Developer

Responsibilities:

• Responsible for interaction with business stake holders, gathering requirements and Maning the delivery, covering the entire Tableau development lifecycle.
• Installation, maintenance and administration of Tableau Servers.
• Experience in Marks,Publisher and Security.
• Experience with creating Worksheets, Dashboarding and infographics.
• Working with Multiple Data Connections.
• Used Snow flake and Star Schema Designs for data modelling.
• Experience with troubleshooting.
• Experience in tableau created Rapid Analytics and Reporting.
• Experience withTableau 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.
• Expertise in Tableau Analysis.
• Experience in BI interactive Dashboards and TableauPublisher.
• Experience in developing Dashboard using OLAP cubes.
• Experience of Client-Interaction on onsite/Offshore.
• Involved in Test Evaluation, Summary Reports.
• Experience in managing users, groups and integration with Active directory
• Live, optimized connections to Teradata to leverage the investments.
• Expertise in connecting to Oracle and SQL databases and troubleshooting.
• Created and updated server architecture for scheduling tasks.
• Analyzed and resolved performance and server based issues.
• Prepared backups using Tabadmin and Tabcmd commands.
• Formulated procedures for installation and configuration of Tableau desktop.
• Designed and developed SSIS packages for Tableau dashboards.
• Utilized data blending activities for Tableau functionalities.
• Participated in performance tracking activity by evaluating server tasks.
• Modified data visualization dashboards and developed data connections

Environment: Tableau Server 6.1, Tableau Desktop 6.1, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008 SSAS, Oracle 11i, Sybase, Crystal XI, Info view, CMS, CMC, Excel, JAVA, J2EE, Tomcat., TSQL, UNIX, Linux RHEL 5.

Confidential

Business System Analyst

Responsibilities:

• Worked with project manager, traders, and other stakeholders to define project scope, plan, and requirements.
• ConductedJADsessions with the stakeholders, end users and SME, to determine the criticalbusinessprocesses and identify key functional requirements for system adhering to the financial regulations and policies.
• Implemented change management after the application is in production and ensured the changes moved into production via DBA and ETL and were implemented in production with all approvals
• Involved in preparing Logical Data Models and conducted controlled brain-storming sessions with project focus groups.
• Identified businessprocess and developedbusinessprocess flow diagrams for loan preapproval, loan application and loan process with the halp ofMS Visio.
• Performed GAP analysis of current new account opening processes and compare with proposed system enhancement.
• Used Rational Rose to design Use Case diagrams, Activity diagrams, and Sequence Diagrams to simplify thebusinessprocess for stakeholders and developers
• Implemented Referential Integrity using primary key and foreign key relationships.
• Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions.
• Used Erwin tool for relational database and dimensional data warehouse designs.
• Designed complex report Published to Crystal Enterprise for end users to view, schedule, and share reports over the web (Info View).
• Created documentation and test cases, worked with users for new module enhancements and testing. Conducted logical data model walkthroughs and validation.
• Used Crystal Reports to generate reports from different databases of different asset classes like equities, bonds, derivatives, and commodities, for all business needs.

Environment: Erwin 4.0, SQL, PL/SQL, MS Office (Word, Power Point, Access, Excel, Outlook), Lotus notes, Oracle 9i, SQL Server 2005/2000, Business Objects, Informatica.