PROFESSIONAL SUMMARY:

• Having 8+ Years of experience, out of which 7+ years in Banking and financial services and 1 year in Healthcare and Insurance experience
• Hands on experience on SDLC and Agile methodologies
• Extensive Tableau (6/7/8) Experience in Enterprise Environment on windows platform, experience including support, troubleshooting, report design and monitoring of system usage
• Experience in tableau version upgrades from 8.0 (32bit) to 8.1 (64bit) environment
• Experience in Tableau module deliverables such as workbooks, package workbooks, building data views manually and automatically using different charts, graphs
• Creating dynamic view creations, drill down & drill up, Data blending, Query tuning, Performance tuning, cross tabs, writing custom SQLs, forecasting, KPI etc.,
• Documented Tableau best practices to the team to adhere on all visualizations
• Experience in Tableau server High availability configuration (Single, Two & Three Node setups)
• Experience in TABCMD & TABADMIN, Email alerts, scheduling, data backup, SAML & drivers setup activities
• Excellent understanding of Data modeling and developing of star & snow flake schemas
• Converted excel data into tableau understandable format using plug ins
• Providing technical and analytical expertise in responding to complex, specialized report requests
• End to end experience in designing and deploying data visualizations using Tableau
• Coordinating with onshore and offshore teams on day to day activities, ensuring to meet project timelines
• 8 years of Mainframe experience in IBM Mainframes as senior project along with extensive experience as a Data Analyst cum Business Analyst
• Experience in Demand management and Disaster recover management activities
• Experience in preparing Project plan, Execution plan, Test Plan, Test Approach, Test Strategy, Test Cases, and Test Report
• Involved in Prod Support, Change Management, and Release Management
• Experience in End to End process method in Confidential by providing easy and fast resolution to merchant payment issues
• Experience on creating weekly and Monthly reports in application level and show the availability number to Amex

TECHNICAL SKILLS:

Reporting tools: Tableau Desktop, Tableau Server

Databases: Db2, IMSDB, VSAM

Technology/OS: Windows, MVS on OS/390, Z/OS, UNIX

Languages/Online: Ab Initio, JCL, COBOL, REXX, AS400, ISPF, IMSDC, Control/MTools: File - Aid, IMSUTIL, ICETOOL, JOBTRAC, XMIT, XCOM, NDM, XPEDITOR, Manage Now, Service Now, Info web, FTP, ITSC, CMR, SSR, PRC, CHGMAN.

PROFESSIONAL EXPERIENCE:

Confidential. REDMOND, WA

SR. TABLEAU CONSULTANT

RESPONSIBILITIES:

• Initiating approved projects into clarity (PMT tool) and resource allocations..
• Conducting POC for tableau server setup for non-existing tableau applications
• Creating system design document, process flow document & setting tableau environment based on approvals and licensing requests.
• Conducting SAR review calls for approvals and maintaining approved docs into Share point
• Gather requirements, analyzing, creating schemas if needed, building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Creating projects, sites, groups, users, scheduling reports and extract refresh in Tableau as needed
• Upgrades existing 8.0 32bit to 8.1 64 bit server which facilitates automatic worker upgrades
• Effectively used data blending feature in tableau.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Created Test Cases and documented the Test Results.

ENVIRONMENT: S: Tableau Server v8, Tableau Desktop v8, Windows 2008 Server Standard R2,SQL,Teradata,, DB2, IMSDB, VSAM, Excel and SSIS

Confidential, MILPITAS, CA

TABLEAU CONSULTANT

RESPONSIBILITIES:

• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends, forecast sales, and to track existing customer sales.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 6-8 desktop/Server.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Create interactive reports and dashboards in Tableau Desktop.
• Subscriptions to Reports or Worksheets in Tableau Desktop.
• Created report schedules on Tableau server.
• Administered user, user groups, and scheduled instances for reports in Tableau
• Worked as technical architect in developing strategy, architecture, and technical specifications for
• Created and assisted users in Tableau dashboard development
• Defined best practices for Tableau report development.
• Executed and tested required queries and reports before publishing.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Scheduled frequency and time to refresh data for the when sources are publishes or extracted to server.
• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.
• Created Test Cases and documented the Test Results.

ENVIRONMENT: S: Tableau Server v6/v7, Tableau Desktop v6/v7, Windows, SQL Server, DB2, Excel

Confidential, IRVINE, CA

SENIOR MAINFRAME PROGRAMMER

RESPONSIBILITIES:

• Coordinating a Team of 8 Members on providing round the clock support for capturing systems
• Communicating with Project Stakeholders in all phases of the engagement - Initiation, Planning, Execution, Monitoring & Control, and Closing.
• Create, test and troubleshoot profiles of submitters, file certification of submitters.
• Maintenance/enhancements of the application
• Metrics Driven Management and Application Rationalization activities
• Tracking and Reporting SLA’s
• Direct and manage the Change Control process for the project as a whole by facilitating group meetings, one-on-one interviews and corresponding through emails with work stream owners to discuss the impact of change request on the project.
• Handling GSAM (Global Systems Availability Management) bridge calls during major outages
• Responsible for Disaster Recovery, Demand Management and Security Awareness training activities
• Publishing performance metrics of the project on monthly basis
• Working closely with SMEs, product modeler and Business to understand the functionality of the application and associated business processes
• Attend the GO/NO GO calls with IT PM’s, Development, BSA & Business and help QA to make a decision for deployment into Production. Working closely with SMEs, product modeler and Business to understand the functionality of the application and associated business processes

ENVIRONMENT: S: COBOL, JCL, DB2, DCLGEN, VSAM, File-AID, IMSUTIL, JOBTRAC, Control/M, IMR, PMR, CMR, SSR, PRC, Manage now, Service Now, CHGMAN etc.

Confidential, RICHMOND, VA

MAINFRAME PROGRAMMER

RESPONSIBILITIES:

• Analyze Cool: Plex Code and prepare Functional Understanding Documents.
• Preparing Process Flows and Preparation of Design and Business System Analyze document.
• Preparation of the functional specifications documents and detail design documents
• Development of new programs and Enhancement to existing system using detailed design documents.
• Conducting Peer reviews and preparation of related documents.
• Responsible for analysis of the service requests, Problem identification and fixing the root-causes.
• Interaction with the clients, Business and Solution People.
• Involved in setting up the system and the process flow. Very much involved in giving suggestions for the quality and performance during the conversion. Identified discrepancies between expected and actual results. Provided documentation to the development team for debugging.

ENVIRONMENT: Servlets, JSP, Oracle, J2EE

Confidential, DENVER, CO

MAINFRAME PROGRAMMER

RESPONSIBILITIES:

• Communicating with Project Stakeholders in all phases of the engagement - Initiation, Planning, Execution, Monitoring & Control, and Closing.
• Direct and manage the Change Control process for the project as a whole by facilitating group meetings, one-on-one interviews and corresponding through emails with work stream owners to discuss the impact of change request on the project.
• Act as the primary liaison between the business units such as Rating, Forms & policy print, to collect business requirements.
• Worked on technical specs & coding COBOL, DB2 and VSAM programs.
• Prep execution JCL using JCLPREP prior to execution and created GDG bases and empty VSAM files when necessary.
• Investigating the problems of abended jobs in different production systems and restart/rerun the jobs.
• Perform risk analysis of the requirements to identify the key business risk areas for the project and prioritize the application development and testing.
• Recommended some impact decisions. Performed regression integration and functional testing on the builds of the application.
• Analyzed the data using SPUFI.
• Participated in project planning activities to determine testing scope.
• Created and modified the JCL scripts while setting up the test environment.
• Prepared Test plans and Test cases based on business and functional requirement.
• Created Test scripts for the different modules of the system and conducted functional and Regression Testing of the application.
• Responsible for setting up test JCL and PROCS in multiple environments for multiple code releases.
• Any further maintenance on the deployed changes are support defect management process. My involvement here is analyzing the defect, identifying the jeevasolution, prepare & present the PTC & DD in the review meeting, implement the changes after approval, followed with testing & deployment.
• Transmitted Production libraries and members to the test region and edited them for testing purposes.
• Built test Scenarios and Test cases (negative / positive) to validate as expected results.
• Verifying that the JCL, PROC, SYSIN changes are completed.

ENVIRONMENT: OS (IBM MVS/VM), COBOL II, MF COBOL, CICS, DB2, JCL, VSAM, IMS, TSO/ISPF, XPEDITOR, File Aid & IDCAMS.